package com.tongfusoft.contract.service;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.tongfusoft.da.help.DBUtils;

public class ContractService {
	
	public Map<String, Object> get(String tempName) {

		String sql = "select TEMPLATE_ID,TEMPLATE_NAME,TEMPLATE_CONTENT,REMARK,IS_CHECK, CHECK_NOTE,CHECK_BY,CHECK_DATE,CREATED_BY,CREATED_DATE, LAST_UPD_BY,LAST_UPD_DATE from tcm_contract_template t where t.status='1' and t.template_name='"
				+ tempName + "' ";
		List<Map<String, Object>> list = DBUtils.executeSelectDynamic(sql);
		if (list.size() > 0) {
			return list.get(0);
		}
		return new HashMap<String, Object>();
	}

}
